2015-05-26 - 19490.100 - Enhancement - Logic to delete unwanted records #InventoryManagement

SPECIFICATIONS

19490.100 - Logic to delete unwanted records

Requirement Summary

Need to make necessary corrections to inventory infocube to prevent unwanted "Not Assigned" Seasons / Collections from appearing in analysis data source (Bex queries) and reports. Also create new BEx Queries on Inventory Infocube ZIC_INVW for porting the reports from DSO to Infocube.

Admin Info

Purpose
 Need to make necessary corrections to inventory infocube to prevent unwanted "Not Assigned" Seasons / Collections from appearing in analysis data source (Bex queries) and reports.
Also create new BEx Queries on Inventory Infocube ZIC_INVW for porting the reports from DSO to Infocube.
Requested By
 Takehiko Kurata
Spec Created By
 Uday Kumar P
Spec Created Date
 05/26/2015
Spec QA by
 Uday Kumar P
Objects
 VIC_INVW_Q001
Document Status
 Complete

Estimates


SNo
 Activity
 Estimation in Hours
1
 Research
 06
2
 Documentation
 04
3
 Development/ Config
 20
4
 Unit test in DEV
 02
5
 Unit test in QUA
 08
6
 Reports & Queries
 24

TOTAL
 64

References

Prior Tickets

None

Documents

The Weekly Inventory Infocube below shows three Materials that are updated from Sales Analysis cube without Season and Collection, that are causing the “Not Assigned” values in query:
1.png

But the Inventory FM is fetching the following two Materials only that have stock:
2.png

Spec Changes


SNo
 Change Details
 Requested By
 Requested On
 Notes if any
1
 Create new BEx Queries on Inventory Infocube ZIC_INVW for porting the reports from DSO to Infocube.
 Mark Harris
 05/28/2015
 Discussed in Meeting.




















Functional Requirement

Purpose/WHY:

Email From Mark G on 05/26/2015:
Our Japan users are inquiring about a group of materials in the Inventory Analysis Consolidated (VIC_INVW_Q001) query that showing up as “Not Assigned” for season and collection. I have attached the complete list for our Japan Plants, but to start please look into the materials posted below and confirm that they are correctly displaying these values. If you have any questions or need more direction let me know.
Season
 Collection
 Material Description
 Material
#
 #
 3930 GOLF ONPAR MESH BLK WHT D
 11122135


5-PANEL OS FTPATCH DENIM/WT
 11136414


5-PANEL BB MG GONZ BLK/BLK/SWHT
 11100127


5-PANEL BB MG SKATE2 NVY/NVY/SWHT
 11100126


5-PANEL BB NEYYAN BLK/BLK
 11100125


5-PANEL BB NEYYAN NVY/NVY
 11100123


5-PANEL BB NEYYAN SCR/SCR
 11100122


5-PANEL LEATHER 1920 BLK/SWHT
 11136412


5-PANEL LEATHER AAP BLK/SWHT/BLK
 11136411


5-PANEL LEATHER MCMXX BLK/BRW/SWHT
 11136410


5-PANEL SQUARE OS ARMYTWILLBRKLYNGR
 11136409

In Scope:

All BEx Queries based on Inventory DSO.

Out of Scope:

All BEx Queries based on Inventory Infocube.

Solution Summary

1. Need to add new Indicator field in Inventory DSO to indicate that the record got updated from the Inventory FM.
2. Need to write start routine logic to eliminate unwanted records at transformation level from Inventory DSO to Infocube.
3. Need to create new BEx Queries on Inventory Infocube similar to the queries existing on Inventory DSO.
4. Point the Crystal reports to the new BEx queries based on the Inventory Infocube.
5. Create the required transport requests and notify NEC to move them to BPQ and BPP.

Solution Details

1. Need to add new field Indicator ZINV_IND in Inventory DSO ZDSOINVM as indicator to indicate that the record got updated from the Inventory FM.
2. Need to write start routine logic to eliminate unwanted records at transformation level from Inventory DSO ZDSOINVM to Infocube ZIC_INVW.
3. Need to create new BEx Queries on Inventory Infocube ZIC_INVW similar to the queries existing on Inventory DSO.
4. Point the Crystal reports INV300, INV310 and INV350 to the new BEx queries based on the Inventory Infocube ZIC_INVW.
5. Create the required transport requests and notify NEC to move them to BPQ and BPP.

Issues

Additional unwanted records that are updated from Sales Analysis Infocube and Open Order Infocube to Inventory DSO cannot be filtered using logic as it will cause performance issue for lookup logic. These records are excluded while updating the records to the Inventory Infocube by using Indicator logic.